At 10:01 PM -0500 12/27/00, Wayne Davis wrote:
>I'm having trouble getting the postgresql jdbc driver to work.
>Here's my error:
>java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getConnection(DriverManager.java,
>Compiled Code)
> at java.sql.DriverManager.getConnection(DriverManager.java,
>Compiled Code)
> at DBBean.<init>(DBBean.java, Compiled Code)
> at DBBean.main(DBBean.java, Compiled Code)
Maybe you had the same naming issue I found (see below).
John DeSoi, Ph.D.
-------
X-From_: desoi@icx.net Wed Dec 20 10:57:45 2000
X-Sender: desoi@mailhub.icx.net (Unverified)
Date: Wed, 20 Dec 2000 10:55:39 -0500
To: peter@retep.org.uk
From: John DeSoi <desoi@icx.net>
Subject: JDBC documentation error
Hi Peter,
I'm just getting started with postgres and JDBC. I wanted to mention
a documentation error that might cause considerable pain for other
newbies like me :)
You have:
In the first method, your code implicitly loads the driver using the
Class.forName() method. For Postgres, you would use:
Class.forName("postgresql.Driver");
In using this, my application kept crashing (of course it should have
given me an error message, but for some reason it just crashed). I
finally got things working by changing it to
Class.forName("org.postgresql.Driver");
Thanks for all your work,
John DeSoi, Ph.D.